﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="hotelinformation.aspx.vb" Inherits="hotels.hotelinformation" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">


People thought this hotel was: 




    <br />
    <br />
    <br />
    <br />
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT DISTINCT [Tag], [ID] FROM [HotelTagView] WHERE ([ID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:BulletedList ID="BulletedList1" runat="server" 
        DataSourceID="SqlDataSource4" DataTextField="Tag" DataValueField="Tag">
    </asp:BulletedList>
    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT DISTINCT [Tag], [ID] FROM [HotelTagView] WHERE ([ID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    <br />
    <br />




    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="HotelName" HeaderText="HotelName" 
                SortExpression="HotelName" />
            <asp:BoundField DataField="Description" HeaderText="Description" 
                SortExpression="Description" />
            <asp:ImageField DataImageUrlField="Picture">
            </asp:ImageField>
        </Columns>
    </asp:GridView>

    <br />
    <br />
    N<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
        DataSourceID="commentsDataSource" Height="167px" Width="325px">
        <Columns>
            <asp:TemplateField HeaderText="Comments">
            <ItemTemplate>
            <div style="background-color:Silver">
            <h1><%# Eval("Subject")%></h1>
            <h2><%# Eval("Author")%></h2>
            <p><%# Eval("Message")%></p>
            </div>
            </ItemTemplate>
            <AlternatingItemTemplate>
            <div style="background-color:White">
            <h1><%# Eval("Subject")%></h1>
            <h2><%# Eval("Author")%></h2>
            <p><%# Eval("Message")%></p>
            </div>
            
            
            </AlternatingItemTemplate>




            </asp:TemplateField>
        </Columns>
    </asp:GridView>

    <br />
     <br />
    New Tags Separated By Comman<br />
    <asp:TextBox ID="tb_NewTags" runat="server" Width="278px"></asp:TextBox>
     <br />

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT [HotelName], [Description], [Picture] FROM [hotellist] WHERE ([ID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter DefaultValue="1" Name="ID" QueryStringField="ID" 
                Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

    <asp:CheckBoxList ID="CheckBoxList1" runat="server" 
        DataSourceID="SqlDataSource2" DataTextField="Tag" DataValueField="ID" 
        RepeatDirection="Horizontal">
    </asp:CheckBoxList>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT [ID], [Tag] FROM [Tags]"></asp:SqlDataSource>

    <br />
    <asp:Button ID="Button2" runat="server" Text="Button" Width="119px" />
    <br />
    <br />

    <div style="overflow:auto;height:300px">
    </div>
    <asp:SqlDataSource ID="commentsDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:hotelsConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:hotelsConnectionString.ProviderName %>" 
        SelectCommand="SELECT [Author], [Subject], [Message] FROM [Comments] WHERE ([HotelID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="HotelID" QueryStringField="ID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    <br />
    <strong>Add Your Comment
    <asp:LoginName ID="LoginName1" runat="server" />
    <br />
    <br />
    Title
    <br />
    <asp:TextBox ID="tb_Subject" runat="server" Width="319px"></asp:TextBox>
    <br />
    Your Comment
    <br />
    <asp:TextBox ID="tb_Message" runat="server" Height="146px" Width="337px" 
        TextMode="MultiLine"></asp:TextBox>
    <br />
    <br />
    <asp:Button ID="Button1" runat="server" Text="Button" Width="148px" />
    </strong>

</asp:Content>
